-
Re: Can Someone QA my Formula?
Thanks again @Mark.poole Helper columns to the rescue. I made a column for each criteria on my sheet with a logic statement in each to return 1 if the cell was not blank. Then I added a fifth column …1 · -
Re: In need of human brain to resolve AI formula.
@Kelly Moore YES! That did it! Thank you for sticking this out with me ;) Human beings for the win! Meredith1 · -
Re: UPDATE: Is there a way to ignore case in a unique identifier
OK - I think I figured my own problem out. I'll run make sure my identifiers are lower case with the =LOWER(@row) formula - and move this result over to my source sheet via data shuttle so it's not a…1 · -
Re: How to input data into target sheet from a source without a unique ID
WHOA @Paul Newcome. Your solution is far simpler than mine 😳 This worked like a charm!1 · -
Re: Cross sheet formula to return a date based on drop down category
Thank you so much for this explanation @Samuel Mueller! This makes sense - and I can apply this logic to other cases.... And it worked! I appreciate the time you took on this! Meredith1 ·